[dbo].[BAEEventSetupCheckMemberStatus]
SQLServer
>
iMIS1521GA
>
Stored Procedures
> dbo.BAEEventSetupCheckMemberStatus
Properties
Parameters
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Parameters
Name
Data Type
Max Length (Bytes)
@memberType
varchar(5)
5
SQL Script
create
procedure
[dbo]
.
[BAEEventSetupCheckMemberStatus]
@memberType
varchar
(
5
)
as
SELECT
mrc.REGISTRANT_CLASS
,
mrc.DESCRIPTION
FROM
Meet_Reg_Class
mrc
WHERE
mrc.REGISTRANT_CLASS
=
@memberType
;
GO
Uses
[dbo].[Meet_Reg_Class]
dbo